<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_goods`;");
E_C("CREATE TABLE `ecs_goods` (
  `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_sn` varchar(60) NOT NULL DEFAULT '',
  `goods_name` varchar(120) NOT NULL DEFAULT '',
  `goods_name_style` varchar(60) NOT NULL DEFAULT '+',
  `click_count` int(10) unsigned NOT NULL DEFAULT '0',
  `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `provider_name` varchar(100) NOT NULL DEFAULT '',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_weight` decimal(10,3) unsigned NOT NULL DEFAULT '0.000',
  `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `shop_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `promote_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `promote_start_date` int(11) unsigned NOT NULL DEFAULT '0',
  `promote_end_date` int(11) unsigned NOT NULL DEFAULT '0',
  `warn_number` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `goods_brief` varchar(255) NOT NULL DEFAULT '',
  `goods_desc` text NOT NULL,
  `goods_thumb` varchar(255) NOT NULL DEFAULT '',
  `goods_img` varchar(255) NOT NULL DEFAULT '',
  `original_img` varchar(255) NOT NULL DEFAULT '',
  `is_real` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `extension_code` varchar(30) NOT NULL DEFAULT '',
  `is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `is_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `integral` int(10) unsigned NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `last_update` int(10) unsigned NOT NULL DEFAULT '0',
  `goods_type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `seller_note` varchar(255) NOT NULL DEFAULT '',
  `give_integral` int(11) NOT NULL DEFAULT '-1',
  `rank_integral` int(11) NOT NULL DEFAULT '-1',
  `suppliers_id` smallint(5) unsigned DEFAULT NULL,
  `is_check` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`goods_id`),
  KEY `goods_sn` (`goods_sn`),
  KEY `cat_id` (`cat_id`),
  KEY `last_update` (`last_update`),
  KEY `brand_id` (`brand_id`),
  KEY `goods_weight` (`goods_weight`),
  KEY `promote_end_date` (`promote_end_date`),
  KEY `promote_start_date` (`promote_start_date`),
  KEY `goods_number` (`goods_number`),
  KEY `sort_order` (`sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_goods` values('1','2','ECS000000','玻璃种老坑玉三彩手镯玻璃种老坑玉三彩手镯','+','55','0','','1','0.000','33600.00','28000.00','0.00','0','0','1','手镯 其他 新玉 碧玉','','<div class=\"default\">\r\n<p><img src=\"http://42.96.150.228/data/files/store_1060/goods_70/201401271514301273.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元1.jpg\" /><img src=\"http://42.96.150.228/data/files/store_1060/goods_70/201401271514306347.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元3.jpg\" /><img src=\"http://42.96.150.228/data/files/store_1060/goods_70/201401271514306708.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元2.jpg\" /><img src=\"http://42.96.150.228/data/files/store_1060/goods_70/201401271514308419.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元4.jpg\" /><img src=\"http://42.96.150.228/data/files/store_1060/goods_70/201401271514307970.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元5.jpg\" /><img src=\"http://42.96.150.228/data/files/store_1060/goods_71/201401271514314239.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元6.jpg\" /><img src=\"http://42.96.150.228/data/files/store_1060/goods_71/201401271514315795.jpg\" alt=\"玻璃种老坑玉三彩手镯1080000元7.jpg\" /></p>\r\n</div>','images/201404/thumb_img/1_thumb_G_1398655646443.jpg','images/201404/goods_img/1_G_1398655646736.jpg','images/201404/source_img/1_G_1398655646126.jpg','1','','1','1','0','280','1398655646','100','0','0','0','1','0','0','1398761064','1','','-1','-1','0','0');");
E_D("replace into `ecs_goods` values('2','2','ECS000002','冰种手镯','+','67','1','','1','0.000','21600.00','18000.00','0.00','0','0','1','手镯 天使 老玉 白玉','','<div class=\"w830 clearfix\"><dl class=\"clearfix in-disina\">                         <dt><img width=\"372\" height=\"342\" src=\"/themes/yumeiren/images/lbigming.jpg\" alt=\"\" /></dt>                         <dd>\r\n<p>详情：</p>\r\n<p>产品材质：纯天然</p>\r\n<p>产品产地：基金酷话白胡椒</p>\r\n<p>产品尺寸：67年技术监督局教科书</p>\r\n<p>产品重量：30-50g</p>\r\n<p>产品种色：糯种</p>\r\n<p>产品描述：计划表黄骏国跪羊图v本计划表国际化美女吧关于建立排版</p>\r\n<p>适宜人群：老人，小孩，，，</p>\r\n</dd>                     </dl>\r\n<div class=\"in-disibox\"><img width=\"830\" height=\"1244\" src=\"/themes/yumeiren/images/msimgbg.jpg\" alt=\"\" /></div>\r\n</div>','images/201405/thumb_img/2_thumb_G_1399254679156.jpg','images/201404/goods_img/2_G_1398656935650.jpg','images/201404/source_img/2_G_1398656935109.jpg','1','','1','1','0','180','1398656741','100','0','0','0','1','0','0','1399254679','2','','-1','-1','0','0');");

require("../../inc/footer.php");
?>